Name |
|
Code |
|
Comment |
Asortyment magazynów |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
ID asortymentu magazynu |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Opis |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Asortyment dostepny |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Nazwa |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data poczatku obowiazywania/okresu |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data konca obowiazywania/okresu |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
Yes |
Comment |
Flaga aktywnosci w systemie |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Lek wymaga zatwierdzenia dyrekcji przy zamówieniu |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Lek wymaga pacjenta przy zamówieniu |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
Yes |
Comment |
Lek pochodzi z importu docelowego |
Name |
|
Code |
|
Data Type |
VARCHAR2(50) |
Mandatory |
No |
Comment |
Identyfikatory ze starego systemu |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Lek wymaga zgody ordynatora przy zamawianiu |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
do zapisu linku do zewnetrznej charakterystyki leku |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
FK do tabeli |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
|
|
|
|